﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CDmDjkOrdersInfo" targetNamespace="http://tempuri.org/CDmDjkOrdersInfo.xsd" xmlns:mstns="http://tempuri.org/CDmDjkOrdersInfo.xsd" xmlns="http://tempuri.org/CDmDjkOrdersInfo.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="dijiekeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dijiekeConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.dijiekeConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DJK_ORDERS_INFOTableAdapter" GeneratorDataComponentClassName="DJK_ORDERS_INFOTableAdapter" Name="DJK_ORDERS_INFO" UserDataComponentName="DJK_ORDERS_INFOTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dijiekeConnectionString (Settings)" DbObjectName="dijieke.dbo.DJK_ORDERS_INFO" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DJK_ORDERS_INFO] WHERE (([ORDERS_INFO_ID] = @Original_ORDERS_INFO_ID) AND ([ORDER_TIME] = @Original_ORDER_TIME) AND ([ORDER_CODE] = @Original_ORDER_CODE) AND ((@IsNull_ORDER_CONTENT = 1 AND [ORDER_CONTENT] IS NULL) OR ([ORDER_CONTENT] = @Original_ORDER_CONTENT)) AND ([ORDER_STATUS] = @Original_ORDER_STATUS) AND ((@IsNull_ORDER_BY_IP = 1 AND [ORDER_BY_IP] IS NULL) OR ([ORDER_BY_IP] = @Original_ORDER_BY_IP)) AND ([ORDER_START_TIME] = @Original_ORDER_START_TIME) AND ([ORDER_STOP_TIME] = @Original_ORDER_STOP_TIME) AND ([ORDER_DJACK_CHECK] = @Original_ORDER_DJACK_CHECK) AND ((@IsNull_DJACK_CHECK_TIME = 1 AND [DJACK_CHECK_TIME] IS NULL) OR ([DJACK_CHECK_TIME] = @Original_DJACK_CHECK_TIME)) AND ((@IsNull_ORDER_TOTAL_BALANCE = 1 AND [ORDER_TOTAL_BALANCE] IS NULL) OR ([ORDER_TOTAL_BALANCE] = @Original_ORDER_TOTAL_BALANCE)) AND ((@IsNull_DISCOUNT_AMT = 1 AND [DISCOUNT_AMT] IS NULL) OR ([DISCOUNT_AMT] = @Original_DISCOUNT_AMT)) AND ((@IsNull_PAYABLE_AMT = 1 AND [PAYABLE_AMT] IS NULL) OR ([PAYABLE_AMT] = @Original_PAYABLE_AMT)) AND ((@IsNull_PAID_AMT = 1 AND [PAID_AMT] IS NULL) OR ([PAID_AMT] = @Original_PAID_AMT)) AND ((@IsNull_ORDER_PAIED_TIME = 1 AND [ORDER_PAIED_TIME] IS NULL) OR ([ORDER_PAIED_TIME] = @Original_ORDER_PAIED_TIME)) AND ([ORDER_IS_CUSTOMER_DEL] = @Original_ORDER_IS_CUSTOMER_DEL) AND ([ORDER_IS_DJACK_DEL] = @Original_ORDER_IS_DJACK_DEL) AND ((@IsNull_ORDER_CUSDEL_TIME = 1 AND [ORDER_CUSDEL_TIME] IS NULL) OR ([ORDER_CUSDEL_TIME] = @Original_ORDER_CUSDEL_TIME)) AND ((@IsNull_ORDER_DJACKDEL_TIME = 1 AND [ORDER_DJACKDEL_TIME] IS NULL) OR ([ORDER_DJACKDEL_TIME] = @Original_ORDER_DJACKDEL_TIME)) AND ([ORDER_HAS_REFUND] = @Original_ORDER_HAS_REFUND) AND ([ORDER_REFUND_FINISH] = @Original_ORDER_REFUND_FINISH) AND ((@IsNull_ORDER_RMK = 1 AND [ORDER_RMK] IS NULL) OR ([ORDER_RMK] = @Original_ORDER_RMK)) AND ([ORDER_BUYER_ID] = @Original_ORDER_BUYER_ID) AND ([ORDER_SOLDER_ID] = @Original_ORDER_SOLDER_ID) AND ((@IsNull_ORDER_EXTENCE_PRICE = 1 AND [ORDER_EXTENCE_PRICE] IS NULL) OR ([ORDER_EXTENCE_PRICE] = @Original_ORDER_EXTENCE_PRICE)) AND ((@IsNull_CHARGE_CCY = 1 AND [CHARGE_CCY] IS NULL) OR ([CHARGE_CCY] = @Original_CHARGE_CCY)) AND ((@IsNull_REFUSE_MESSAGE = 1 AND [REFUSE_MESSAGE] IS NULL) OR ([REFUSE_MESSAGE] = @Original_REFUSE_MESSAGE)) AND ((@IsNull_IS_PAIEDFOR_DJK = 1 AND [IS_PAIEDFOR_DJK] IS NULL) OR ([IS_PAIEDFOR_DJK] = @Original_IS_PAIEDFOR_DJK)) AND ((@IsNull_PAIEDFOR_DJK_DT = 1 AND [PAIEDFOR_DJK_DT] IS NULL) OR ([PAIEDFOR_DJK_DT] = @Original_PAIEDFOR_DJK_DT)) AND ((@IsNull_DEPOSIT_RATIO = 1 AND [DEPOSIT_RATIO] IS NULL) OR ([DEPOSIT_RATIO] = @Original_DEPOSIT_RATIO)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDERS_INFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDERS_INFO_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_CONTENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_CONTENT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_CONTENT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CONTENT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_BY_IP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_BY_IP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_BY_IP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_BY_IP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_START_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_START_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_STOP_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_STOP_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ORDER_DJACK_CHECK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_DJACK_CHECK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_CHECK_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_CHECK_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DJACK_CHECK_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DJACK_CHECK_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_TOTAL_BALANCE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_TOTAL_BALANCE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ORDER_TOTAL_BALANCE" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_TOTAL_BALANCE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DISCOUNT_AMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DISCOUNT_AMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DISCOUNT_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DISCOUNT_AMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAYABLE_AMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAYABLE_AMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PAYABLE_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PAYABLE_AMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAID_AMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAID_AMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PAID_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PAID_AMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_PAIED_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_PAIED_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_PAIED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_PAIED_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ORDER_IS_CUSTOMER_DEL" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_IS_CUSTOMER_DEL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ORDER_IS_DJACK_DEL" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_IS_DJACK_DEL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_CUSDEL_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_CUSDEL_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_CUSDEL_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_CUSDEL_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_DJACKDEL_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_DJACKDEL_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_DJACKDEL_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_DJACKDEL_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ORDER_HAS_REFUND" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_HAS_REFUND" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ORDER_REFUND_FINISH" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_REFUND_FINISH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_RMK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_RMK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_RMK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_BUYER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_BUYER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_SOLDER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_SOLDER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_EXTENCE_PRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_EXTENCE_PRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ORDER_EXTENCE_PRICE" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_EXTENCE_PRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHARGE_CCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHARGE_CCY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CHARGE_CCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHARGE_CCY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REFUSE_MESSAGE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REFUSE_MESSAGE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_REFUSE_MESSAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REFUSE_MESSAGE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_PAIEDFOR_DJK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_PAIEDFOR_DJK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_PAIEDFOR_DJK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_PAIEDFOR_DJK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAIEDFOR_DJK_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAIEDFOR_DJK_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PAIEDFOR_DJK_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PAIEDFOR_DJK_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DEPOSIT_RATIO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DEPOSIT_RATIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DEPOSIT_RATIO" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DEPOSIT_RATIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DJK_ORDERS_INFO] ([ORDERS_INFO_ID], [ORDER_TIME], [ORDER_CODE], [ORDER_CONTENT], [ORDER_STATUS], [ORDER_BY_IP], [ORDER_START_TIME], [ORDER_STOP_TIME], [ORDER_DJACK_CHECK], [DJACK_CHECK_TIME], [ORDER_TOTAL_BALANCE], [DISCOUNT_AMT], [PAYABLE_AMT], [PAID_AMT], [ORDER_PAIED_TIME], [ORDER_IS_CUSTOMER_DEL], [ORDER_IS_DJACK_DEL], [ORDER_CUSDEL_TIME], [ORDER_DJACKDEL_TIME], [ORDER_HAS_REFUND], [ORDER_REFUND_FINISH], [ORDER_RMK], [ORDER_BUYER_ID], [ORDER_SOLDER_ID], [ORDER_EXTENCE_PRICE], [CHARGE_CCY], [REFUSE_MESSAGE], [IS_PAIEDFOR_DJK], [PAIEDFOR_DJK_DT], [DEPOSIT_RATIO]) VALUES (@ORDERS_INFO_ID, @ORDER_TIME, @ORDER_CODE, @ORDER_CONTENT, @ORDER_STATUS, @ORDER_BY_IP, @ORDER_START_TIME, @ORDER_STOP_TIME, @ORDER_DJACK_CHECK, @DJACK_CHECK_TIME, @ORDER_TOTAL_BALANCE, @DISCOUNT_AMT, @PAYABLE_AMT, @PAID_AMT, @ORDER_PAIED_TIME, @ORDER_IS_CUSTOMER_DEL, @ORDER_IS_DJACK_DEL, @ORDER_CUSDEL_TIME, @ORDER_DJACKDEL_TIME, @ORDER_HAS_REFUND, @ORDER_REFUND_FINISH, @ORDER_RMK, @ORDER_BUYER_ID, @ORDER_SOLDER_ID, @ORDER_EXTENCE_PRICE, @CHARGE_CCY, @REFUSE_MESSAGE, @IS_PAIEDFOR_DJK, @PAIEDFOR_DJK_DT, @DEPOSIT_RATIO);
SELECT ORDERS_INFO_ID, ORDER_TIME, ORDER_CODE, ORDER_CONTENT, ORDER_STATUS, ORDER_BY_IP, ORDER_START_TIME, ORDER_STOP_TIME, ORDER_DJACK_CHECK, DJACK_CHECK_TIME, ORDER_TOTAL_BALANCE, DISCOUNT_AMT, PAYABLE_AMT, PAID_AMT, ORDER_PAIED_TIME, ORDER_IS_CUSTOMER_DEL, ORDER_IS_DJACK_DEL, ORDER_CUSDEL_TIME, ORDER_DJACKDEL_TIME, ORDER_HAS_REFUND, ORDER_REFUND_FINISH, ORDER_RMK, ORDER_BUYER_ID, ORDER_SOLDER_ID, ORDER_EXTENCE_PRICE, CHARGE_CCY, REFUSE_MESSAGE, IS_PAIEDFOR_DJK, PAIEDFOR_DJK_DT, DEPOSIT_RATIO FROM DJK_ORDERS_INFO WHERE (ORDERS_INFO_ID = @ORDERS_INFO_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDERS_INFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDERS_INFO_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_CONTENT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CONTENT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_BY_IP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_BY_IP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_START_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_START_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_STOP_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_STOP_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ORDER_DJACK_CHECK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_DJACK_CHECK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DJACK_CHECK_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DJACK_CHECK_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ORDER_TOTAL_BALANCE" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_TOTAL_BALANCE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DISCOUNT_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DISCOUNT_AMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PAYABLE_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PAYABLE_AMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PAID_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PAID_AMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_PAIED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_PAIED_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ORDER_IS_CUSTOMER_DEL" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_IS_CUSTOMER_DEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ORDER_IS_DJACK_DEL" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_IS_DJACK_DEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_CUSDEL_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_CUSDEL_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_DJACKDEL_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_DJACKDEL_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ORDER_HAS_REFUND" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_HAS_REFUND" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ORDER_REFUND_FINISH" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_REFUND_FINISH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_RMK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_BUYER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_BUYER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_SOLDER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_SOLDER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ORDER_EXTENCE_PRICE" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_EXTENCE_PRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CHARGE_CCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHARGE_CCY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@REFUSE_MESSAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REFUSE_MESSAGE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_PAIEDFOR_DJK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_PAIEDFOR_DJK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PAIEDFOR_DJK_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PAIEDFOR_DJK_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DEPOSIT_RATIO" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DEPOSIT_RATIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ORDERS_INFO_ID, ORDER_TIME, ORDER_CODE, ORDER_CONTENT, ORDER_STATUS, ORDER_BY_IP, ORDER_START_TIME, ORDER_STOP_TIME, ORDER_DJACK_CHECK, DJACK_CHECK_TIME, ORDER_TOTAL_BALANCE, DISCOUNT_AMT, PAYABLE_AMT, PAID_AMT, ORDER_PAIED_TIME, ORDER_IS_CUSTOMER_DEL, ORDER_IS_DJACK_DEL, ORDER_CUSDEL_TIME, ORDER_DJACKDEL_TIME, ORDER_HAS_REFUND, ORDER_REFUND_FINISH, ORDER_RMK, ORDER_BUYER_ID, ORDER_SOLDER_ID, ORDER_EXTENCE_PRICE, CHARGE_CCY, REFUSE_MESSAGE, IS_PAIEDFOR_DJK, PAIEDFOR_DJK_DT, DEPOSIT_RATIO FROM dbo.DJK_ORDERS_INFO</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DJK_ORDERS_INFO] SET [ORDERS_INFO_ID] = @ORDERS_INFO_ID, [ORDER_TIME] = @ORDER_TIME, [ORDER_CODE] = @ORDER_CODE, [ORDER_CONTENT] = @ORDER_CONTENT, [ORDER_STATUS] = @ORDER_STATUS, [ORDER_BY_IP] = @ORDER_BY_IP, [ORDER_START_TIME] = @ORDER_START_TIME, [ORDER_STOP_TIME] = @ORDER_STOP_TIME, [ORDER_DJACK_CHECK] = @ORDER_DJACK_CHECK, [DJACK_CHECK_TIME] = @DJACK_CHECK_TIME, [ORDER_TOTAL_BALANCE] = @ORDER_TOTAL_BALANCE, [DISCOUNT_AMT] = @DISCOUNT_AMT, [PAYABLE_AMT] = @PAYABLE_AMT, [PAID_AMT] = @PAID_AMT, [ORDER_PAIED_TIME] = @ORDER_PAIED_TIME, [ORDER_IS_CUSTOMER_DEL] = @ORDER_IS_CUSTOMER_DEL, [ORDER_IS_DJACK_DEL] = @ORDER_IS_DJACK_DEL, [ORDER_CUSDEL_TIME] = @ORDER_CUSDEL_TIME, [ORDER_DJACKDEL_TIME] = @ORDER_DJACKDEL_TIME, [ORDER_HAS_REFUND] = @ORDER_HAS_REFUND, [ORDER_REFUND_FINISH] = @ORDER_REFUND_FINISH, [ORDER_RMK] = @ORDER_RMK, [ORDER_BUYER_ID] = @ORDER_BUYER_ID, [ORDER_SOLDER_ID] = @ORDER_SOLDER_ID, [ORDER_EXTENCE_PRICE] = @ORDER_EXTENCE_PRICE, [CHARGE_CCY] = @CHARGE_CCY, [REFUSE_MESSAGE] = @REFUSE_MESSAGE, [IS_PAIEDFOR_DJK] = @IS_PAIEDFOR_DJK, [PAIEDFOR_DJK_DT] = @PAIEDFOR_DJK_DT, [DEPOSIT_RATIO] = @DEPOSIT_RATIO WHERE (([ORDERS_INFO_ID] = @Original_ORDERS_INFO_ID) AND ([ORDER_TIME] = @Original_ORDER_TIME) AND ([ORDER_CODE] = @Original_ORDER_CODE) AND ((@IsNull_ORDER_CONTENT = 1 AND [ORDER_CONTENT] IS NULL) OR ([ORDER_CONTENT] = @Original_ORDER_CONTENT)) AND ([ORDER_STATUS] = @Original_ORDER_STATUS) AND ((@IsNull_ORDER_BY_IP = 1 AND [ORDER_BY_IP] IS NULL) OR ([ORDER_BY_IP] = @Original_ORDER_BY_IP)) AND ([ORDER_START_TIME] = @Original_ORDER_START_TIME) AND ([ORDER_STOP_TIME] = @Original_ORDER_STOP_TIME) AND ([ORDER_DJACK_CHECK] = @Original_ORDER_DJACK_CHECK) AND ((@IsNull_DJACK_CHECK_TIME = 1 AND [DJACK_CHECK_TIME] IS NULL) OR ([DJACK_CHECK_TIME] = @Original_DJACK_CHECK_TIME)) AND ((@IsNull_ORDER_TOTAL_BALANCE = 1 AND [ORDER_TOTAL_BALANCE] IS NULL) OR ([ORDER_TOTAL_BALANCE] = @Original_ORDER_TOTAL_BALANCE)) AND ((@IsNull_DISCOUNT_AMT = 1 AND [DISCOUNT_AMT] IS NULL) OR ([DISCOUNT_AMT] = @Original_DISCOUNT_AMT)) AND ((@IsNull_PAYABLE_AMT = 1 AND [PAYABLE_AMT] IS NULL) OR ([PAYABLE_AMT] = @Original_PAYABLE_AMT)) AND ((@IsNull_PAID_AMT = 1 AND [PAID_AMT] IS NULL) OR ([PAID_AMT] = @Original_PAID_AMT)) AND ((@IsNull_ORDER_PAIED_TIME = 1 AND [ORDER_PAIED_TIME] IS NULL) OR ([ORDER_PAIED_TIME] = @Original_ORDER_PAIED_TIME)) AND ([ORDER_IS_CUSTOMER_DEL] = @Original_ORDER_IS_CUSTOMER_DEL) AND ([ORDER_IS_DJACK_DEL] = @Original_ORDER_IS_DJACK_DEL) AND ((@IsNull_ORDER_CUSDEL_TIME = 1 AND [ORDER_CUSDEL_TIME] IS NULL) OR ([ORDER_CUSDEL_TIME] = @Original_ORDER_CUSDEL_TIME)) AND ((@IsNull_ORDER_DJACKDEL_TIME = 1 AND [ORDER_DJACKDEL_TIME] IS NULL) OR ([ORDER_DJACKDEL_TIME] = @Original_ORDER_DJACKDEL_TIME)) AND ([ORDER_HAS_REFUND] = @Original_ORDER_HAS_REFUND) AND ([ORDER_REFUND_FINISH] = @Original_ORDER_REFUND_FINISH) AND ((@IsNull_ORDER_RMK = 1 AND [ORDER_RMK] IS NULL) OR ([ORDER_RMK] = @Original_ORDER_RMK)) AND ([ORDER_BUYER_ID] = @Original_ORDER_BUYER_ID) AND ([ORDER_SOLDER_ID] = @Original_ORDER_SOLDER_ID) AND ((@IsNull_ORDER_EXTENCE_PRICE = 1 AND [ORDER_EXTENCE_PRICE] IS NULL) OR ([ORDER_EXTENCE_PRICE] = @Original_ORDER_EXTENCE_PRICE)) AND ((@IsNull_CHARGE_CCY = 1 AND [CHARGE_CCY] IS NULL) OR ([CHARGE_CCY] = @Original_CHARGE_CCY)) AND ((@IsNull_REFUSE_MESSAGE = 1 AND [REFUSE_MESSAGE] IS NULL) OR ([REFUSE_MESSAGE] = @Original_REFUSE_MESSAGE)) AND ((@IsNull_IS_PAIEDFOR_DJK = 1 AND [IS_PAIEDFOR_DJK] IS NULL) OR ([IS_PAIEDFOR_DJK] = @Original_IS_PAIEDFOR_DJK)) AND ((@IsNull_PAIEDFOR_DJK_DT = 1 AND [PAIEDFOR_DJK_DT] IS NULL) OR ([PAIEDFOR_DJK_DT] = @Original_PAIEDFOR_DJK_DT)) AND ((@IsNull_DEPOSIT_RATIO = 1 AND [DEPOSIT_RATIO] IS NULL) OR ([DEPOSIT_RATIO] = @Original_DEPOSIT_RATIO)));
SELECT ORDERS_INFO_ID, ORDER_TIME, ORDER_CODE, ORDER_CONTENT, ORDER_STATUS, ORDER_BY_IP, ORDER_START_TIME, ORDER_STOP_TIME, ORDER_DJACK_CHECK, DJACK_CHECK_TIME, ORDER_TOTAL_BALANCE, DISCOUNT_AMT, PAYABLE_AMT, PAID_AMT, ORDER_PAIED_TIME, ORDER_IS_CUSTOMER_DEL, ORDER_IS_DJACK_DEL, ORDER_CUSDEL_TIME, ORDER_DJACKDEL_TIME, ORDER_HAS_REFUND, ORDER_REFUND_FINISH, ORDER_RMK, ORDER_BUYER_ID, ORDER_SOLDER_ID, ORDER_EXTENCE_PRICE, CHARGE_CCY, REFUSE_MESSAGE, IS_PAIEDFOR_DJK, PAIEDFOR_DJK_DT, DEPOSIT_RATIO FROM DJK_ORDERS_INFO WHERE (ORDERS_INFO_ID = @ORDERS_INFO_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDERS_INFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDERS_INFO_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CODE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_CONTENT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CONTENT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ORDER_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_BY_IP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_BY_IP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_START_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_START_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_STOP_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_STOP_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ORDER_DJACK_CHECK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_DJACK_CHECK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DJACK_CHECK_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DJACK_CHECK_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ORDER_TOTAL_BALANCE" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_TOTAL_BALANCE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DISCOUNT_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DISCOUNT_AMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PAYABLE_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PAYABLE_AMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PAID_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PAID_AMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_PAIED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_PAIED_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ORDER_IS_CUSTOMER_DEL" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_IS_CUSTOMER_DEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ORDER_IS_DJACK_DEL" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_IS_DJACK_DEL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_CUSDEL_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_CUSDEL_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ORDER_DJACKDEL_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_DJACKDEL_TIME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ORDER_HAS_REFUND" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_HAS_REFUND" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ORDER_REFUND_FINISH" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_REFUND_FINISH" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_RMK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_BUYER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_BUYER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDER_SOLDER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_SOLDER_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ORDER_EXTENCE_PRICE" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_EXTENCE_PRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CHARGE_CCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHARGE_CCY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@REFUSE_MESSAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REFUSE_MESSAGE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_PAIEDFOR_DJK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_PAIEDFOR_DJK" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PAIEDFOR_DJK_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PAIEDFOR_DJK_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DEPOSIT_RATIO" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DEPOSIT_RATIO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDERS_INFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDERS_INFO_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_CODE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CODE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_CONTENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_CONTENT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_CONTENT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_CONTENT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ORDER_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_BY_IP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_BY_IP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_BY_IP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_BY_IP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_START_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_START_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_STOP_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_STOP_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ORDER_DJACK_CHECK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_DJACK_CHECK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DJACK_CHECK_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DJACK_CHECK_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DJACK_CHECK_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DJACK_CHECK_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_TOTAL_BALANCE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_TOTAL_BALANCE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ORDER_TOTAL_BALANCE" Precision="20" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_TOTAL_BALANCE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DISCOUNT_AMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DISCOUNT_AMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DISCOUNT_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DISCOUNT_AMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAYABLE_AMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAYABLE_AMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PAYABLE_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PAYABLE_AMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAID_AMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAID_AMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PAID_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PAID_AMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_PAIED_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_PAIED_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_PAIED_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_PAIED_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ORDER_IS_CUSTOMER_DEL" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_IS_CUSTOMER_DEL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ORDER_IS_DJACK_DEL" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_IS_DJACK_DEL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_CUSDEL_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_CUSDEL_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_CUSDEL_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_CUSDEL_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_DJACKDEL_TIME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_DJACKDEL_TIME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ORDER_DJACKDEL_TIME" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ORDER_DJACKDEL_TIME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ORDER_HAS_REFUND" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_HAS_REFUND" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ORDER_REFUND_FINISH" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ORDER_REFUND_FINISH" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_RMK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_RMK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_RMK" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_RMK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_BUYER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_BUYER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDER_SOLDER_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDER_SOLDER_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDER_EXTENCE_PRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDER_EXTENCE_PRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_ORDER_EXTENCE_PRICE" Precision="10" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="ORDER_EXTENCE_PRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHARGE_CCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHARGE_CCY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CHARGE_CCY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHARGE_CCY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REFUSE_MESSAGE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REFUSE_MESSAGE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_REFUSE_MESSAGE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REFUSE_MESSAGE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_PAIEDFOR_DJK" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_PAIEDFOR_DJK" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_PAIEDFOR_DJK" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_PAIEDFOR_DJK" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAIEDFOR_DJK_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAIEDFOR_DJK_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PAIEDFOR_DJK_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PAIEDFOR_DJK_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DEPOSIT_RATIO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DEPOSIT_RATIO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DEPOSIT_RATIO" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DEPOSIT_RATIO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ORDERS_INFO_ID" DataSetColumn="ORDERS_INFO_ID" />
              <Mapping SourceColumn="ORDER_TIME" DataSetColumn="ORDER_TIME" />
              <Mapping SourceColumn="ORDER_CODE" DataSetColumn="ORDER_CODE" />
              <Mapping SourceColumn="ORDER_CONTENT" DataSetColumn="ORDER_CONTENT" />
              <Mapping SourceColumn="ORDER_STATUS" DataSetColumn="ORDER_STATUS" />
              <Mapping SourceColumn="ORDER_BY_IP" DataSetColumn="ORDER_BY_IP" />
              <Mapping SourceColumn="ORDER_START_TIME" DataSetColumn="ORDER_START_TIME" />
              <Mapping SourceColumn="ORDER_STOP_TIME" DataSetColumn="ORDER_STOP_TIME" />
              <Mapping SourceColumn="ORDER_DJACK_CHECK" DataSetColumn="ORDER_DJACK_CHECK" />
              <Mapping SourceColumn="DJACK_CHECK_TIME" DataSetColumn="DJACK_CHECK_TIME" />
              <Mapping SourceColumn="ORDER_TOTAL_BALANCE" DataSetColumn="ORDER_TOTAL_BALANCE" />
              <Mapping SourceColumn="DISCOUNT_AMT" DataSetColumn="DISCOUNT_AMT" />
              <Mapping SourceColumn="PAYABLE_AMT" DataSetColumn="PAYABLE_AMT" />
              <Mapping SourceColumn="PAID_AMT" DataSetColumn="PAID_AMT" />
              <Mapping SourceColumn="ORDER_PAIED_TIME" DataSetColumn="ORDER_PAIED_TIME" />
              <Mapping SourceColumn="ORDER_IS_CUSTOMER_DEL" DataSetColumn="ORDER_IS_CUSTOMER_DEL" />
              <Mapping SourceColumn="ORDER_IS_DJACK_DEL" DataSetColumn="ORDER_IS_DJACK_DEL" />
              <Mapping SourceColumn="ORDER_CUSDEL_TIME" DataSetColumn="ORDER_CUSDEL_TIME" />
              <Mapping SourceColumn="ORDER_DJACKDEL_TIME" DataSetColumn="ORDER_DJACKDEL_TIME" />
              <Mapping SourceColumn="ORDER_HAS_REFUND" DataSetColumn="ORDER_HAS_REFUND" />
              <Mapping SourceColumn="ORDER_REFUND_FINISH" DataSetColumn="ORDER_REFUND_FINISH" />
              <Mapping SourceColumn="ORDER_RMK" DataSetColumn="ORDER_RMK" />
              <Mapping SourceColumn="ORDER_BUYER_ID" DataSetColumn="ORDER_BUYER_ID" />
              <Mapping SourceColumn="ORDER_SOLDER_ID" DataSetColumn="ORDER_SOLDER_ID" />
              <Mapping SourceColumn="ORDER_EXTENCE_PRICE" DataSetColumn="ORDER_EXTENCE_PRICE" />
              <Mapping SourceColumn="CHARGE_CCY" DataSetColumn="CHARGE_CCY" />
              <Mapping SourceColumn="REFUSE_MESSAGE" DataSetColumn="REFUSE_MESSAGE" />
              <Mapping SourceColumn="IS_PAIEDFOR_DJK" DataSetColumn="IS_PAIEDFOR_DJK" />
              <Mapping SourceColumn="PAIEDFOR_DJK_DT" DataSetColumn="PAIEDFOR_DJK_DT" />
              <Mapping SourceColumn="DEPOSIT_RATIO" DataSetColumn="DEPOSIT_RATIO" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CDmDjkOrdersInfo" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CDmDjkOrdersInfo" msprop:Generator_UserDSName="CDmDjkOrdersInfo">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DJK_ORDERS_INFO" msprop:Generator_TableClassName="DJK_ORDERS_INFODataTable" msprop:Generator_TableVarName="tableDJK_ORDERS_INFO" msprop:Generator_TablePropName="DJK_ORDERS_INFO" msprop:Generator_RowDeletingName="DJK_ORDERS_INFORowDeleting" msprop:Generator_RowChangingName="DJK_ORDERS_INFORowChanging" msprop:Generator_RowEvHandlerName="DJK_ORDERS_INFORowChangeEventHandler" msprop:Generator_RowDeletedName="DJK_ORDERS_INFORowDeleted" msprop:Generator_UserTableName="DJK_ORDERS_INFO" msprop:Generator_RowChangedName="DJK_ORDERS_INFORowChanged" msprop:Generator_RowEvArgName="DJK_ORDERS_INFORowChangeEvent" msprop:Generator_RowClassName="DJK_ORDERS_INFORow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ORDERS_INFO_ID" msprop:Generator_ColumnVarNameInTable="columnORDERS_INFO_ID" msprop:Generator_ColumnPropNameInRow="ORDERS_INFO_ID" msprop:Generator_ColumnPropNameInTable="ORDERS_INFO_IDColumn" msprop:Generator_UserColumnName="ORDERS_INFO_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_TIME" msprop:Generator_ColumnVarNameInTable="columnORDER_TIME" msprop:Generator_ColumnPropNameInRow="ORDER_TIME" msprop:Generator_ColumnPropNameInTable="ORDER_TIMEColumn" msprop:Generator_UserColumnName="ORDER_TIME" type="xs:dateTime" />
              <xs:element name="ORDER_CODE" msprop:Generator_ColumnVarNameInTable="columnORDER_CODE" msprop:Generator_ColumnPropNameInRow="ORDER_CODE" msprop:Generator_ColumnPropNameInTable="ORDER_CODEColumn" msprop:Generator_UserColumnName="ORDER_CODE">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_CONTENT" msprop:Generator_ColumnVarNameInTable="columnORDER_CONTENT" msprop:Generator_ColumnPropNameInRow="ORDER_CONTENT" msprop:Generator_ColumnPropNameInTable="ORDER_CONTENTColumn" msprop:Generator_UserColumnName="ORDER_CONTENT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_STATUS" msprop:Generator_ColumnVarNameInTable="columnORDER_STATUS" msprop:Generator_ColumnPropNameInRow="ORDER_STATUS" msprop:Generator_ColumnPropNameInTable="ORDER_STATUSColumn" msprop:Generator_UserColumnName="ORDER_STATUS" type="xs:int" />
              <xs:element name="ORDER_BY_IP" msprop:Generator_ColumnVarNameInTable="columnORDER_BY_IP" msprop:Generator_ColumnPropNameInRow="ORDER_BY_IP" msprop:Generator_ColumnPropNameInTable="ORDER_BY_IPColumn" msprop:Generator_UserColumnName="ORDER_BY_IP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_START_TIME" msprop:Generator_ColumnVarNameInTable="columnORDER_START_TIME" msprop:Generator_ColumnPropNameInRow="ORDER_START_TIME" msprop:Generator_ColumnPropNameInTable="ORDER_START_TIMEColumn" msprop:Generator_UserColumnName="ORDER_START_TIME" type="xs:dateTime" />
              <xs:element name="ORDER_STOP_TIME" msprop:Generator_ColumnVarNameInTable="columnORDER_STOP_TIME" msprop:Generator_ColumnPropNameInRow="ORDER_STOP_TIME" msprop:Generator_ColumnPropNameInTable="ORDER_STOP_TIMEColumn" msprop:Generator_UserColumnName="ORDER_STOP_TIME" type="xs:dateTime" />
              <xs:element name="ORDER_DJACK_CHECK" msprop:Generator_ColumnVarNameInTable="columnORDER_DJACK_CHECK" msprop:Generator_ColumnPropNameInRow="ORDER_DJACK_CHECK" msprop:Generator_ColumnPropNameInTable="ORDER_DJACK_CHECKColumn" msprop:Generator_UserColumnName="ORDER_DJACK_CHECK" type="xs:boolean" />
              <xs:element name="DJACK_CHECK_TIME" msprop:Generator_ColumnVarNameInTable="columnDJACK_CHECK_TIME" msprop:Generator_ColumnPropNameInRow="DJACK_CHECK_TIME" msprop:Generator_ColumnPropNameInTable="DJACK_CHECK_TIMEColumn" msprop:Generator_UserColumnName="DJACK_CHECK_TIME" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ORDER_TOTAL_BALANCE" msprop:Generator_ColumnVarNameInTable="columnORDER_TOTAL_BALANCE" msprop:Generator_ColumnPropNameInRow="ORDER_TOTAL_BALANCE" msprop:Generator_ColumnPropNameInTable="ORDER_TOTAL_BALANCEColumn" msprop:Generator_UserColumnName="ORDER_TOTAL_BALANCE" type="xs:decimal" minOccurs="0" />
              <xs:element name="DISCOUNT_AMT" msprop:Generator_ColumnVarNameInTable="columnDISCOUNT_AMT" msprop:Generator_ColumnPropNameInRow="DISCOUNT_AMT" msprop:Generator_ColumnPropNameInTable="DISCOUNT_AMTColumn" msprop:Generator_UserColumnName="DISCOUNT_AMT" type="xs:decimal" minOccurs="0" />
              <xs:element name="PAYABLE_AMT" msprop:Generator_ColumnVarNameInTable="columnPAYABLE_AMT" msprop:Generator_ColumnPropNameInRow="PAYABLE_AMT" msprop:Generator_ColumnPropNameInTable="PAYABLE_AMTColumn" msprop:Generator_UserColumnName="PAYABLE_AMT" type="xs:decimal" minOccurs="0" />
              <xs:element name="PAID_AMT" msprop:Generator_ColumnVarNameInTable="columnPAID_AMT" msprop:Generator_ColumnPropNameInRow="PAID_AMT" msprop:Generator_ColumnPropNameInTable="PAID_AMTColumn" msprop:Generator_UserColumnName="PAID_AMT" type="xs:decimal" minOccurs="0" />
              <xs:element name="ORDER_PAIED_TIME" msprop:Generator_ColumnVarNameInTable="columnORDER_PAIED_TIME" msprop:Generator_ColumnPropNameInRow="ORDER_PAIED_TIME" msprop:Generator_ColumnPropNameInTable="ORDER_PAIED_TIMEColumn" msprop:Generator_UserColumnName="ORDER_PAIED_TIME" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ORDER_IS_CUSTOMER_DEL" msprop:Generator_ColumnVarNameInTable="columnORDER_IS_CUSTOMER_DEL" msprop:Generator_ColumnPropNameInRow="ORDER_IS_CUSTOMER_DEL" msprop:Generator_ColumnPropNameInTable="ORDER_IS_CUSTOMER_DELColumn" msprop:Generator_UserColumnName="ORDER_IS_CUSTOMER_DEL" type="xs:boolean" />
              <xs:element name="ORDER_IS_DJACK_DEL" msprop:Generator_ColumnVarNameInTable="columnORDER_IS_DJACK_DEL" msprop:Generator_ColumnPropNameInRow="ORDER_IS_DJACK_DEL" msprop:Generator_ColumnPropNameInTable="ORDER_IS_DJACK_DELColumn" msprop:Generator_UserColumnName="ORDER_IS_DJACK_DEL" type="xs:boolean" />
              <xs:element name="ORDER_CUSDEL_TIME" msprop:Generator_ColumnVarNameInTable="columnORDER_CUSDEL_TIME" msprop:Generator_ColumnPropNameInRow="ORDER_CUSDEL_TIME" msprop:Generator_ColumnPropNameInTable="ORDER_CUSDEL_TIMEColumn" msprop:Generator_UserColumnName="ORDER_CUSDEL_TIME" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ORDER_DJACKDEL_TIME" msprop:Generator_ColumnVarNameInTable="columnORDER_DJACKDEL_TIME" msprop:Generator_ColumnPropNameInRow="ORDER_DJACKDEL_TIME" msprop:Generator_ColumnPropNameInTable="ORDER_DJACKDEL_TIMEColumn" msprop:Generator_UserColumnName="ORDER_DJACKDEL_TIME" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ORDER_HAS_REFUND" msprop:Generator_ColumnVarNameInTable="columnORDER_HAS_REFUND" msprop:Generator_ColumnPropNameInRow="ORDER_HAS_REFUND" msprop:Generator_ColumnPropNameInTable="ORDER_HAS_REFUNDColumn" msprop:Generator_UserColumnName="ORDER_HAS_REFUND" type="xs:boolean" />
              <xs:element name="ORDER_REFUND_FINISH" msprop:Generator_ColumnVarNameInTable="columnORDER_REFUND_FINISH" msprop:Generator_ColumnPropNameInRow="ORDER_REFUND_FINISH" msprop:Generator_ColumnPropNameInTable="ORDER_REFUND_FINISHColumn" msprop:Generator_UserColumnName="ORDER_REFUND_FINISH" type="xs:boolean" />
              <xs:element name="ORDER_RMK" msprop:Generator_ColumnVarNameInTable="columnORDER_RMK" msprop:Generator_ColumnPropNameInRow="ORDER_RMK" msprop:Generator_ColumnPropNameInTable="ORDER_RMKColumn" msprop:Generator_UserColumnName="ORDER_RMK" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_BUYER_ID" msprop:Generator_ColumnVarNameInTable="columnORDER_BUYER_ID" msprop:Generator_ColumnPropNameInRow="ORDER_BUYER_ID" msprop:Generator_ColumnPropNameInTable="ORDER_BUYER_IDColumn" msprop:Generator_UserColumnName="ORDER_BUYER_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_SOLDER_ID" msprop:Generator_ColumnVarNameInTable="columnORDER_SOLDER_ID" msprop:Generator_ColumnPropNameInRow="ORDER_SOLDER_ID" msprop:Generator_ColumnPropNameInTable="ORDER_SOLDER_IDColumn" msprop:Generator_UserColumnName="ORDER_SOLDER_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDER_EXTENCE_PRICE" msprop:Generator_ColumnVarNameInTable="columnORDER_EXTENCE_PRICE" msprop:Generator_ColumnPropNameInRow="ORDER_EXTENCE_PRICE" msprop:Generator_ColumnPropNameInTable="ORDER_EXTENCE_PRICEColumn" msprop:Generator_UserColumnName="ORDER_EXTENCE_PRICE" type="xs:decimal" minOccurs="0" />
              <xs:element name="CHARGE_CCY" msprop:Generator_ColumnVarNameInTable="columnCHARGE_CCY" msprop:Generator_ColumnPropNameInRow="CHARGE_CCY" msprop:Generator_ColumnPropNameInTable="CHARGE_CCYColumn" msprop:Generator_UserColumnName="CHARGE_CCY" type="xs:int" minOccurs="0" />
              <xs:element name="REFUSE_MESSAGE" msprop:Generator_ColumnVarNameInTable="columnREFUSE_MESSAGE" msprop:Generator_ColumnPropNameInRow="REFUSE_MESSAGE" msprop:Generator_ColumnPropNameInTable="REFUSE_MESSAGEColumn" msprop:Generator_UserColumnName="REFUSE_MESSAGE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IS_PAIEDFOR_DJK" msprop:Generator_ColumnVarNameInTable="columnIS_PAIEDFOR_DJK" msprop:Generator_ColumnPropNameInRow="IS_PAIEDFOR_DJK" msprop:Generator_ColumnPropNameInTable="IS_PAIEDFOR_DJKColumn" msprop:Generator_UserColumnName="IS_PAIEDFOR_DJK" type="xs:boolean" minOccurs="0" />
              <xs:element name="PAIEDFOR_DJK_DT" msprop:Generator_ColumnVarNameInTable="columnPAIEDFOR_DJK_DT" msprop:Generator_ColumnPropNameInRow="PAIEDFOR_DJK_DT" msprop:Generator_ColumnPropNameInTable="PAIEDFOR_DJK_DTColumn" msprop:Generator_UserColumnName="PAIEDFOR_DJK_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DEPOSIT_RATIO" msprop:Generator_ColumnVarNameInTable="columnDEPOSIT_RATIO" msprop:Generator_ColumnPropNameInRow="DEPOSIT_RATIO" msprop:Generator_ColumnPropNameInTable="DEPOSIT_RATIOColumn" msprop:Generator_UserColumnName="DEPOSIT_RATIO" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DJK_ORDERS_INFO" />
      <xs:field xpath="mstns:ORDERS_INFO_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>